﻿namespace WFC.DAL.StatementSources
{

    internal class ReadRefDataByIdStatementSource : StatementSourceBase
    {
        internal ReadRefDataByIdStatementSource(int categoryId)
        {
            Sql = "SELECT `Key`,`Value` FROM `wfc`.`RefDataCategories` WHERE `CategoryId`=@CategoryId;";

            Parameters.AddWithValue("@CategoryId", categoryId);
        }
    }

    internal class ReadAllRefDataStatementSource : StatementSourceBase
    {
        internal ReadAllRefDataStatementSource()
        {
            Sql = "SELECT `Key`,`Value` FROM `wfc`.`RefDataCategories`;";
        }
    }

}
